/**
 *
 *@author ZhouLan
 *@version 1.0.0
 */

import relationalStore from '@ohos.data.relationalStore';
export default {
  config:{
    name:'address.db',
    securityLevel:relationalStore.SecurityLevel.S1
  },
  sql:[
    'CREATE TABLE IF NOT EXISTS PROVINCE(ID INTEGER PRIMARY KEY,CODE TEXT,NAME TEXT,SHORT_NAME TEXT,PARENT_CODE TEXT,LNG TEXT,LAT TEXT,SORT INTEGER,GMT_CREATE TEXT,GMT_MODIFIED TEXT,MEMO TEXT,DATA_STATE INTEGER,TENANT_CODE TEXT)'
    ,
    'CREATE TABLE IF NOT EXISTS CITY(ID INTEGER PRIMARY KEY,CODE TEXT,NAME TEXT,SHORT_NAME TEXT,PARENT_CODE TEXT,LNG TEXT,LAT TEXT,SORT INTEGER,GMT_CREATE TEXT,GMT_MODIFIED TEXT,MEMO TEXT,DATA_STATE INTEGER,TENANT_CODE TEXT)'
    ,
    'CREATE TABLE IF NOT EXISTS AREA(ID INTEGER PRIMARY KEY,CODE TEXT,NAME TEXT,SHORT_NAME TEXT,PARENT_CODE TEXT,LNG TEXT,LAT TEXT,SORT INTEGER,GMT_CREATE TEXT,GMT_MODIFIED TEXT,MEMO TEXT,DATA_STATE INTEGER,TENANT_CODE TEXT)'
    ,
    'CREATE TABLE IF NOT EXISTS STREET(ID INTEGER PRIMARY KEY,CODE TEXT,NAME TEXT,SHORT_NAME TEXT,PARENT_CODE TEXT,LNG TEXT,LAT TEXT,SORT INTEGER,GMT_CREATE TEXT,GMT_MODIFIED TEXT,MEMO TEXT,DATA_STATE INTEGER,TENANT_CODE TEXT)'
  ]
}